Class: Table | .\src\TW\Utils\MiniTable.py | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Table( (
|
Base Classes | |
---|---|
UserList |
Methods | |
---|---|
DELETE INSERT INSERT_ROWS SELECT UPDATE __init__ | |
DELETE | |
DELETE ( self, **where ) table.DELETE(field1=value1, field2=value2...)Delete rows which match the field values asserted in the keyword arguments. Affects only the specific table it is called upon. | |
INSERT | |
INSERT ( self, **values ) table.INSERT(field1=value1, field2=value2...)Insert a row with the supplied field values. Affects only the specific table it is called upon. | |
INSERT_ROWS | |
INSERT_ROWS ( self, colNames, rowList, ) table.INSERT_ROWS(colnames tuple, rowlist) Insert table.INSERT_ROWS( ('foo','bar','baz'), [ ( 1, 2, 3), ( 4, 5, 6), ]) The above is equivalent to: table.INSERT(foo=1,bar=2,baz=3) table.INSERT(foo=4,bar=5,baz=6) | |
SELECT | |
SELECT ( self, **where ) table.SELECT(field1=value1, field2=value2...) -> Table slice | |
UPDATE | |
UPDATE ( self, **setVals ) table.UPDATE(setCol1=setVal1, setCol2=setVal2...) Sets the specified column values for all rows in the table.
This is most useful in conjunction with table.SELECT(foo=27).UPDATE(bar=50) The above would set | |
__init__ | |
__init__ ( self, colNames=(), rowList=(), rawData=None, ) |